The database:
Here is the database we will be working with. Please:
- copy all the cells below
- open excel
- paste the cells into excel.
This is a database of people with arthritis who were given a treatment improve pain management techniques. We want to see if the well-being of the people who received the treatment improved compared to those who did not receive the treatment.
Copy the database and make sure you put the column "Username" in cell A1 on the excel database. If you paste the database in to a different part of the excel spreadsheet the formula given in this program will need to be adjusted.
The database:
| Username | Gender | Age at symptom onset | Age | Disease duration (years) | Group | Baseline Wellbeing | End of study wellbeing |
| 1 | 0 | 18 | 35 | 17 | 0 | 15 | 20 |
| 2 | 0 | 21 | 40 | 19 | 1 | 20 | 15 |
| 3 | 1 | 15 | 45 | 30 | 0 | 54.5 | 60.1 |
| 4 | 0 | 35 | 43 | 8 | 0 | 52 | 60 |
| 5 | 1 | 19 | 47 | 28 | 0 | 56 | 71.2 |
| 6 | 1 | 35 | 20 | 0 | 0 | 45 | 33 |
| 7 | 0 | 21 | 50 | 29 | 0 | 6 | 20 |
| 8 | 1 | 35 | 59 | 24 | 1 | 16 | 10 |
| 9 | 1 | 18 | 46 | 28 | 0 | 39 | 70 |
| 10 | 1 | 20 | 62 | 42 | 0 | 54 | 59.6 |
| 11 | 1 | 21 | 55 | 34 | 0 | 15 | 60 |
| 12 | 0 | 22 | 40 | 18 | 0 | 17 | 30 |
| 13 | 0 | 18 | 54 | 36 | 1 | 30 | 20 |
| 14 | 1 | 40 | 43 | 3 | 1 | 60 | 50.2 |
| 15 | 1 | 14 | 36 | 22 | 0 | 5 | 15 |
| 16 | 1 | 16 | 34 | 18 | 1 | 9.5 | 5 |
| 17 | 1 | 25 | 45 | 20 | 1 | 12 | 4 |
| 18 | 0 | 22 | 25 | 3 | 0 | 20 | 70.4 |
| 19 | 1 | 28 | 42 | 14 | 1 | 34 | 25.6 |
| 20 | 1 | 26 | 52 | 26 | 0 | 16 | 40 |
| 21 | 0 | 19 | 29 | 10 | 1 | 24 | 10 |
| 22 | 1 | 23 | 30 | 7 | 0 | 34 | 35 |
| 23 | 1 | 28 | 51 | 23 | 0 | 53.5 | 60 |
| 24 | 1 | 19 | 28 | 9 | 1 | 29.5 | 15 |
| 25 | 1 | 28 | 40 | 12 | 1 | 51 | 37 |
| 26 | 0 | 17 | 48 | 31 | 1 | 7 | 6 |
| 27 | 1 | 22 | 41 | 19 | 0 | 1 | 60 |
| 28 | 1 | 30 | 64 | 34 | 0 | 10 | 20 |
| 29 | 1 | 24 | 32 | 8 | 1 | 63 | 30 |
| 30 | 1 | 22 | 57 | 35 | 1 | 39 | 30 |
